
create external table jms_ods.sys_customer_entity_relation
(
    entity_code    string comment '店铺实体编码',
    customer_code  string comment '客户(店铺)编号',
    create_time    timestamp comment '创建时间',
    create_by_code string comment '创建人code',
    create_by_name string comment '创建人名称'
)
comment '实体店铺关联表'
    PARTITIONED BY (dt STRING COMMENT '时间分区')
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_ods.db/external/sys_customer_entity_relation'
    TBLPROPERTIES (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );
